Formula Editor
Use the Formula Editor to create and edit formulas. The Formula Editor contains four main windows.
Window
| Description of contents
|
Report Fields
| Report fields contain all database fields accessible for your report. They also contain any formulas or groups already created for the report.
|
Functions
| Functions are prebuilt procedures that return values. They perform calculations such as average, sum, count, sin, trim, and uppercase.
|
Operators
| Operators are the "action verbs" you use in formulas. They describe an operation or an action to take place between two or more values.
Examples of operators: add, subtract, less than, and greater than.
|
Formula text window
| Area where you create or edit a formula.
|
Note: Changing the syntax from Crystal syntax to Basic syntax or vice versa will change the list of functions in the Functions window as well as the list of operators in the Operators window. The functions and operators differ from syntax to syntax.
Create a formula by double-clicking on any of the components listed in the Report Fields, Functions, or Operators trees. When you choose a component, the required syntax is also inserted. You can also manually enter a formula.
When you are finished creating or editing a formula, click Check to identify any errors in the formula and click Save and Close to save the formula and return to your report.
Note: The following shortcut keys work in the Formula Editor:
- New (Ctrl+N)
- Save (Alt+S)
- Save and close (Ctrl+S)
- Check (Alt+C)
- Name (Ctrl+M)
- Undo (Alt+Back Space, or Ctrl+Z)
- Redo (Ctrl+Shift+Z)
- Browse Data (Alt+B)
- Find/Replace (Ctrl+F)
- Toggle Bookmark (Ctrl+F2)
- Next Bookmark (F2)
- Previous Bookmark (Shift+F2)
- Clear All Bookmarks (Ctrl+Shift+F2)
- Sort trees (Ctrl+O)
- Field Tree (Alt+F)
- Function Tree (Alt+U)
- Operator Tree (Alt+P)
- Help (Alt+H)
- Syntax (Ctrl+T).
For a more complete list of shortcut keys available in the Formula Editor, see Formula Editor Key Controls.
Related topics
Creating a formula and inserting it into a report
Formula Editor buttons
Formula syntax
Operators
Functions
Specifying formulas
Formulas in action
Find dialog box (Formula Editor)